Release 10.1A: OpenEdge Data Management:
Database Administration

Maximum database size

The maximum size of an OpenEdge Version 10 database is determined by the:

Database block size.
Number of records per block in each area.
Number of storage areas.

Database block size and the number of records per block determine the maximum storage area size. The maximum size of a database is determined by the following formulas:

max-database-size = max-storage-area-size * max-number-of-storage-area max-storage-area-size = max-number-db-blocks-per-area * db-block-size max-number-db-blocks-per-area = max-number-records-per-area / recs-per-block

For example, using one (1) record per block and an 8K (8192) byte block size allows a maximum storage area size equal to 16TB (terabytes), and a maximum size of a database to be approximately 16PB (petabytes) as shown in the following calculations:

max-number-db-blocks-per-area = max-number-records-per-area / recs-per-block                               =         2,000,000,000       /      1                               = 2,000,000,000 max-storage-area-size = max-number-db-blocks-per-area * db-block-size                      =       2,000,000,000            *    8192                      = 16384,000,000,000 max-database-size = max-storage-area-size * max-number-of-storage-area                      = 16384,000,000,000     *      1000                      = 16384,000,000,000,000                      = 16PB